SPOOL $HOME/crst_fm/MISC/log/recon_log.log

DEFINE NGO_CODE = '&1'
DEFINE BG_CODE= '&2'
DEFINE NGO_SOB_SHORT_CODE= '&3'

@$HOME/crst_fm/FA/recon/CAPFAREC_ADD_WARRANTIES.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_ADDITIONS_B.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_ADDITIONS_TL.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_ADJUSTMENTS.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_ASSET_HISTORY.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_ASSET_INV.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_BOOK_CTL.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_BOOKS.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_CAT_BOOK.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_CAT_BOOK_DEF.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_DEPRN_DETAIL.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_DEPRN_PERIOD.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_DEPRN_SUMMARY.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_DIST_ACCTS.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_DIST_HIST.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_INV_COMP_REP_ITF.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_INV_INTERFACE.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_INV_TXN.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_INVENTORY.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_INVMISS_REP_ITF.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_JNL_ENTRIES.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_MASS_ADDITIONS.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_MASS_EXT_RET.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_MASS_RECLASS.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_MASS_RECLASS_ITF.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_MASS_RET.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_MASS_TXF.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_MASSADD_DIST.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_RETIREMENTS.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_TXF_DETAILS.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_TXN_HEADERS.sql &NGO_CODE
@$HOME/crst_fm/FA/recon/CAPFAREC_WARRANTIES.sql &NGO_CODE

@$HOME/crst_fm/FND/recon/CAPFNDREC_AFR_SETUP.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_ASSIGNMENT.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_CONC_PROG.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_CONC_PROG_CONTEXT.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_CONC_PROG_CONTEXT_TL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_CONC_PROG_FLEX.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_CONC_PROG_FLEX_TL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_CONC_PROG_PARAM.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_CONC_PROG_PARAM_TL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_CONC_PROG_SERIAL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_CONC_PROG_TL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_DOC_SEQ.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_EMPLOYEE.sql &NGO_CODE
--@$HOME/crst_fm/FND/recon/CAPFNDREC_FORM_FUNCTIONS.sql &NGO_CODE
--@$HOME/crst_fm/FND/recon/CAPFNDREC_FORM_FUNCTIONS_TL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_HIER.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_HIER_TL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_LOCATION.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_LOCATION_TL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_MENU_ENTRIES.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_MENU_ENTRIES_TL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_MENUS.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_MENUS_TL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_MTL_PARA.sql &BG_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_ORG_INFO.sql &BG_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_ORG_UNITS.sql &BG_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_ORG_UNITS_TL.sql &BG_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_PROFILE.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_REQ_SET_PGRM.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_REQ_SET_PGRM_PARAM.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_REQ_SET_STAGE.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_REQ_SET_STAGE_TL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_REQUEST_SETS.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_REQUEST_SETS_TL.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_RESP.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_RESP_REQ_GRP.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_RESP_REQ_GRP_UNITS.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_USER.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_USER_RESP.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_VALUE_SET.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_VALUES.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_VALUES_HIER.sql &NGO_CODE
@$HOME/crst_fm/FND/recon/CAPFNDREC_VALUES_TL.sql &NGO_CODE

@$HOME/crst_fm/GL/recon/CAPGLREC_ALLOC.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_AUTOPOST.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_AUTOREV.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_CALENDAR.sql &NGO_SOB_SHORT_CODE
--@$HOME/crst_fm/GL/recon/CAPGLREC_PERIOD.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_RATE_DAILY.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_RATE_HIST.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_RATE_PERIOD.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_SECURITY.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_SOB.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_BALANCES.sql &NGO_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_BC_PACKET.sql &NGO_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_CODE_COMB.sql &NGO_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_DAILY_CONV_TYPES.sql	&NGO_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_INTERFACE.sql &NGO_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_JE_BATCHES.sql &NGO_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_JE_HEADERS.sql &NGO_CODE
@$HOME/crst_fm/GL/recon/CAPGLREC_JE_LINES.sql	&NGO_CODE

@$HOME/crst_fm/AP/recon/CAPAPREC_ACC_EVENT.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_AE_HEADERS.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_AE_LINES.sql  &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_AP_BANK_AC.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_AP_BANK_AC_USE.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_AP_OPT.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_CHECKRUN_CONF.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_CHECKS.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_ENCUM_LINE.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_FIN_OPT.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_INV_B.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_INV_D.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_INV_I.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_INV_PAYMENT.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_INV_SELECT_CRT.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_PAY_DOC.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_PAY_FORMAT.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_PAY_HISTORY.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_PAY_SCHEDULE.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_SELECT_INV.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_SELECT_INV_CHECKS.sql &NGO_CODE
@$HOME/crst_fm/AP/recon/CAPAPREC_TOLERANCE.sql &NGO_CODE

@$HOME/crst_fm/AR/recon/CAPARREC_SYSTEM_OPTION.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_AUTO_ACCOUNTING.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_TRANSACTION_TYPE &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_TRANSACTION_SOURCE &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_RECEIVABLE_ACTIVITY.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_PAYMENT_METHOD.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_RECEIPT_SOURCE &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_MEMO_LINE.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_APPROVAL_LIMIT.sql &NGO_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_REMIT_TO_ADDRESS.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_DISTRIBUTION_SET.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_DISTRIBUTION_SET_LINE.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_PARTY.sql &BG_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_ACCOUNT.sql &BG_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_PROFILE.sql &BG_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_PARTY_SITE.sql &BG_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_ACCT_SITE.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_LOCATION.sql &NGO_SOB_SHORT_CODE
--@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_LOC_ASSIGNMENT.sql
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_SITE_USE.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_ACCOUNT_ROLE.sql &BG_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_CONTACT.sql &BG_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_CONTACT_POINT.sql &BG_CODE
--@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_RECEIPT_METHOD.sql
@$HOME/crst_fm/AR/recon/CAPARREC_SALESPERSON.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_OM_SYSTEM_PARAM.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_INVOICE_BATCH &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_INVOICE.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_INVOICE_LINE.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_INVOICE_LINE_DIST.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_INVOICE_LINE_SALE.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_INVOICE_ADJUST.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_RECEIPT_BATCH.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_RECEIPT.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_RECEIPT_APPLICATION.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_RECEIPT_MISC_DIST.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_RECEIPT_HISTORY.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_RECEIPT_DIST.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_LOCATION_ASSIGNMENT.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_PARTY_SITE_USE &BG_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_RELATIONSHIP.sql &BG_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_CUSTOMER_PAYMENT_METHOD.sql &BG_CODE
@$HOME/crst_fm/AR/recon/CAPARREC_PAYMENT_SCHEDULE.sql &NGO_SOB_SHORT_CODE

@$HOME/crst_fm/PO/recon/CAPPOREC_APPROVAL_GROUP.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_APPROVAL_GROUP_ASSIGNMENT.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_APPROVAL_PATH.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_APPROVED_SUPPLIER_LIST.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_ATTACHMENT.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_BUYER.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_DOCUMENT_TYPE.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_ITEM.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_LOCATION.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_ORGANIZATION_ACCESS.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_PERSON.sql &BG_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_PERSON_ASSIGNMENT.sql &BG_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_POSITION.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_POSITION_HIERARCHY.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_PURCHASE_OPTION.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_PURCHASE_ORDER_DISTRIBUTION.sql &NGO_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_PURCHASE_ORDER_HEADER.sql &NGO_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_PURCHASE_ORDER_LINE.sql &NGO_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_PURCHASE_ORDER_LINE_LOCATION.sql &NGO_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_RECEIPT_HEADER.sql &NGO_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_RECEIPT_LINE.sql &NGO_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_RECEIPT_TRANSACTION.sql &NGO_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_RECEIVING_OPTION.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_REQUISITION_DISTRIBUTION.sql &NGO_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_REQUISITION_HEADER.sql &NGO_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_REQUISITION_LINE.sql &NGO_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_RFQ_VENDOR.sql &NGO_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_SUPPLIER.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_SUPPLIER_CONTACT.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_SUPPLIER_LIST.sql &NGO_SOB_SHORT_CODE
@$HOME/crst_fm/PO/recon/CAPPOREC_SUPPLIER_SITE.sql &NGO_SOB_SHORT_CODE

SPOOL OFF

QUIT